-- ----------------------------
-- Records of holi_date
-- ----------------------------
BEGIN;
INSERT INTO `holi_date`(`date_time`, `weekday`, `year`, `month`, `day`, `holiday`, `holiday_name`, `holiday_type`)
VALUES
    ('2024-01-01', 1, 2024, 1, 1, 1, '元旦节', 2),
    ('2024-02-04', 0, 2024, 2, 4, 0, '春节补班', 3),
    ('2024-02-10', 6, 2024, 2, 10, 1, '春节第一天', 2),
    ('2024-02-11', 0, 2024, 2, 11, 1, '春节第二天', 2),
    ('2024-02-12', 1, 2024, 2, 12, 1, '春节第三天', 2),
    ('2024-02-13', 2, 2024, 2, 13, 1, '春节第四天', 2),
    ('2024-02-14', 3, 2024, 2, 14, 1, '春节第五天', 2),
    ('2024-02-15', 4, 2024, 2, 15, 1, '春节第六天', 2),
    ('2024-02-16', 5, 2024, 2, 16, 1, '春节第七天', 2),
    ('2024-02-17', 6, 2024, 2, 17, 1, '春节第八天', 2),
    ('2024-02-18', 0, 2024, 2, 18, 0, '春节补班', 3),
    ('2024-04-04', 4, 2024, 4, 4, 1, '清明节第一天', 2),
    ('2024-04-05', 5, 2024, 4, 5, 1, '清明节第二天', 2),
    ('2024-04-06', 6, 2024, 4, 6, 1, '清明节第三天', 2),
    ('2024-04-07', 0, 2024, 4, 7, 0, '清明节补班', 3),
    ('2024-04-28', 0, 2024, 4, 28, 0, '劳动节补班', 3),
    ('2024-05-01', 3, 2024, 5, 1, 1, '劳动节第一天', 2),
    ('2024-05-02', 4, 2024, 5, 2, 1, '劳动节第二天', 2),
    ('2024-05-03', 5, 2024, 5, 3, 1, '劳动节第三天', 2),
    ('2024-05-04', 6, 2024, 5, 4, 1, '劳动节第四天', 2),
    ('2024-05-05', 0, 2024, 5, 5, 1, '劳动节第五天', 2),
    ('2024-05-11', 6, 2024, 5, 11, 0, '劳动节补班', 3),
    ('2024-06-10', 1, 2024, 6, 10, 1, '端午节', 2),
    ('2024-09-14', 6, 2024, 9, 14, 0, '中秋节补班', 3),
    ('2024-09-15', 0, 2024, 9, 15, 1, '中秋节第一天', 2),
    ('2024-09-16', 1, 2024, 9, 16, 1, '中秋节第二天', 2),
    ('2024-09-17', 2, 2024, 9, 17, 1, '中秋节第三天', 2),
    ('2024-09-29', 0, 2024, 9, 29, 0, '国庆节补班', 3),
    ('2024-10-01', 2, 2024, 10, 1, 1, '国庆节第一天', 2),
    ('2024-10-02', 3, 2024, 10, 2, 1, '国庆节第二天', 2),
    ('2024-10-03', 4, 2024, 10, 3, 1, '国庆节第三天', 2),
    ('2024-10-04', 5, 2024, 10, 4, 1, '国庆节第四天', 2),
    ('2024-10-05', 6, 2024, 10, 5, 1, '国庆节第五天', 2),
    ('2024-10-06', 0, 2024, 10, 6, 1, '国庆节第六天', 2),
    ('2024-10-07', 1, 2024, 10, 7, 1, '国庆节第七天', 2),
    ('2024-10-12', 6, 2024, 10, 12, 0, '国庆节补班', 3),

    ;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;